package com.ikas.ai.server.module.data.dorisDao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ikas.ai.server.module.data.model.doris.DorisYcData;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 工况转换流程实例表
 *
 * @author hu.bowei
 * @email hu.bowei@ikasinfo.com
 * @date 2023-05-06 17:12:07
 */
public interface DorisYcDataDao extends BaseMapper<DorisYcData> {
    @Select("SELECT mete_code,mete_name,mete_id,report_time,value FROM t_data_yc WHERE machine_no = #{machineNo} AND mete_code LIKE CONCAT('%', #{equipmentCode}, '%')  AND model_use = 1 AND mete_code IS NOT NULL")
    List<DorisYcData> getLessColumnForDownPut(@Param("machineNo") String machineNo, @Param("equipmentCode") String equipmentCode);
}
